package com.jishuo.nontax.bfc.dao;

import com.jishuo.nontax.bean.vo.BankCheckBillVO;
import com.jishuo.nontax.bean.vo.NumAmtVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @auther dinggaofei
 * @Date 2022/12/21 8:51
 */
@Mapper
public interface BankCheckBillMapper {

    int selectBankCheckBillCount(@Param("bankcheckid") String bankcheckid, @Param("accountnum") String accountnum, @Param("accountdate") String accountdate);

    int updateBankCheckBill(BankCheckBillVO bankCheckBill);

    int insertBankCheckBill(BankCheckBillVO bankCheckBill);

    /** 查询所有对账流水 */
    List<BankCheckBillVO> findSendBankCheckBill(@Param("accountcode") String accountcode, @Param("accountdate")String accountdate);

    int  updateSendBankCheckBill(@Param("accountnum") String accountnum, @Param("accountdate")String accountdate);

    NumAmtVO selectCheckBillNumAmt(@Param("bankid")String bankid, @Param("paybankdt")String paybankdt);


    List<BankCheckBillVO> selwebpay(BankCheckBillVO bankCheckBillVO);

    List<BankCheckBillVO> findBankCheckBill(BankCheckBillVO bankCheckBillVO);

    List<BankCheckBillVO> findCheckBillId(@Param("accountcode") String accountcode, @Param("paybankdt") String paybankdt);
    /**
     * 删除对账流水
     * @param accountcode 账号
     * @param paybankdt 日期
     * @return
     */
    int deleteCheckBill(@Param("accountcode")String accountcode, @Param("paybankdt")String paybankdt);

    int saveCheckBill_1(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt);
    int saveCheckBill_2(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt);
    int saveCheckBill_3(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt);
    int saveCheckBill_4(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt);
    int saveCheckBill_5(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt);
    int saveCheckBill_51(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt);
    int saveCheckBill_6(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt);
    int saveCheckBill_7(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt);
    int saveCheckBill_8(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt, @Param("bankcheckid") String bankcheckid);
    int saveCheckBill_9(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt, @Param("bankcheckid") String bankcheckid);
    int saveCheckBill_10(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt, @Param("bankcheckid") String bankcheckid);
    int saveCheckBill_101(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt, @Param("bankcheckid") String bankcheckid);
    int saveCheckBill_11(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt, @Param("bankcheckid") String bankcheckid);
    int saveCheckBill_12(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt, @Param("bankcheckid") String bankcheckid);
    int saveCheckBill_13(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt, @Param("bankcheckid") String bankcheckid);
    int saveCheckBill_15(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt, @Param("bankcheckid") String bankcheckid);
    int saveCheckBill_16(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt);
    int saveCheckBill_17(@Param("bankid") long bankid, @Param("accountcode") String accountcode, @Param("accountname") String accountname, @Param("paybankdt") String paybankdt);


    int deleteWebpay(BankCheckBillVO bankCheckBillVO);

    int insertWebpay(BankCheckBillVO bankCheckBillVO);

    int updateWebpay(BankCheckBillVO bankCheckBillVO);

    int deleteWebpayIds(String bankcheckids);
}
